This report is focused around Lost and Found data using the intakes and outcomes data received for 2019 and 2020. Its goal is to reflect everything we could learn about L&F from the available data and highlight things that would be useful to show but some/all data required for them are missing.

Report Structure

  1. KPIs: data points that indicate how good the shelter is doing on on L&F. They have numeric goals associated with them.
  2. Supporting data: data points that aren’t a goal themselves but serve as a proxy for improving a goal. For example, the method of RTH is not a performance indicator, but it helps identifying how RTHs take place. The number of strays found per ZIP code is not a metric to improve, but it shows where most strays are coming from to guide resource allocation.
  3. Checklist alignment: whether the practices associated with the HASS Lost and Found element are in place. These might not have a numeric data point that makes sense to collect and track.
  4. Data status: the state of the data received from the shelter, highlighting missing pieces and potential areas for improvement.
  5. Extra metrics: some ideas for additional L&F metrics and the data points they require.

Scroll down or use the table of contents on the left to navigate throughout the document. Most sections contain multiple tabs showing different facets of a data type. Most plots are interactive, meaning they include tooltips and allow hiding and showing parts and zooming in and out. If something went wrong, look for the house icon in the top right corner of each figure to reset.

Executive Summary

  1. RTH rates for dogs have decreased from 22% 2019 to 15% 2020 and remained similar in the first half of 2021. RTH for cats was around 1% across all years.
  2. The decrease in rate was for RTH from the shelter, as field RTH rates remained a constant 4% of field intakes in all three years, whereas the Shelter RTH rates for field intakes decreased from 18% in 2019 to 12 and 13% in 2020 and 2021 respectively.
  3. The RTH rates from animals who did not come from the field also decreased from 2019 (21%) to 2020 (14%) to 2021 (8%).
  4. Despite this sharp decrease in RTH of OTC dogs, even since the lowest rate of 2-3% in March-April 2020, the rate has been steadily increasing up to 11% in June 2021.
  5. The median length of stay for RTH outcomes is 17 days lower than stray intakes with other outcomes. Assuming a $30 daily cost of care per dog, we can estimate that RTH outcomes saved the shelter $1.01m in 2019, $351k in 2020, and $178k in 2021. Using the average length of stay would result in even higher amounts.
  6. Returning even an extra 10% of the dogs who came in as strays so far in 2021 would have resulted in saving roughly $100k.

KPIs

Yearly RTH Rates by Species

This section provides an overview of the RTH rate per year divided by species. RTH Rate is calculated as the portion of returned animals that came in as strays out of stray animals. Animals younger than 6 weeks are excluded (this could be easily changed).

Overall RTH Rate

This table covers all strays and RTHs per year.

Species Year Strays RTH_Count RTH_Rate
Cat 2019 7480 59 0.01
Cat 2020 4361 22 0.01
Cat 2021 2726 11 0.00
Dog 2019 9693 2095 0.22
Dog 2020 4604 695 0.15
Dog 2021 2245 349 0.16
Other 2019 139 12 0.09
Other 2020 99 2 0.02
Other 2021 64 4 0.06

Field Intake RTH Rate

This one only counts animals who came in as strays from the field (using subtype ‘ACO Pickup / Drop Off’ or ‘Stray-Agency’ – are these the right values to include?). These are then split by RTH method between field (using outcome_subtype ‘RTO Field’) and shelter (all other values).

Cats rates are negligible, and while the in-field return rate for dogs is steady, the shelter rate decreased from 2019 to 2020 and 2021.

Species Year Field_Strays RTH_Subtype Field_RTH_Count RTH_Rate
Cat 2019 1000 Field Return 8 0.01
Cat 2019 1000 Shelter Return 5 0.00
Cat 2020 844 Field Return 8 0.01
Cat 2020 844 Shelter Return 2 0.00
Cat 2021 598 Field Return 2 0.00
Cat 2021 598 Shelter Return 4 0.01
Dog 2019 5496 Field Return 227 0.04
Dog 2019 5496 Shelter Return 990 0.18
Dog 2020 3074 Field Return 115 0.04
Dog 2020 3074 Shelter Return 368 0.12
Dog 2021 1833 Field Return 79 0.04
Dog 2021 1833 Shelter Return 237 0.13

Shelter RTH Rate by Species

This shows RTH rates for OTC strays, which includes subtypes ‘Public Drop Off’ and ‘Possible Owner’. These rates also decline from 2019 to 2020 and further in 2021.

Species Year OTC_Strays Shelter_RTH RTH_Rate
Cat 2019 4276 46 0.01
Cat 2020 1930 12 0.01
Cat 2021 1173 5 0.00
Dog 2019 4140 865 0.21
Dog 2020 1481 210 0.14
Dog 2021 401 32 0.08

RTH Over Time

These three time series show the RTH rate per month, to show whether there were times with particularly high or low rates as well as the overall trajectory.

Overall RTH

Again, we start with all RTH (both field and shelter), for cats and dogs. For dogs, there is a clear decrease in the beginning of the pandemic to June 2020, an increase in July 2020 and then a zigzag of better or worse months.

Field RTH (Dogs)

This is the same figure, but only counting field strays, and showing only dogs due to cats’ low numbers. The different lines split the rate of return by Field RTH or in-shelter RTH, so in Jan 2019, for example, 29% of field stray intakes were returned in the shelter and an extra 2% were returned in the field.

The in-shelter RTH numbers zigzag a lot while moderately decreasing over time, while Field returns remain fairly stable except for a few particularly low (Aug 2019, Oct 2020, Dec 2020) and high (Nov 2020, Feb 2021) months.

Shelter RTH

This figure only counts strays who did not come from the field. Before the pandemic the rate was pretty unstable, going between peaks of 25% and lows of 15%, while starting March 2020 there was a sharp decrease to around 5% levels. Since then, however, there is a slow increase every month up to 11% in June 2021.

Stray Intakes

This section shows the number of stray intakes over time, as well as the breakdown of strays by field/shelter intake.

Stray Intakes by Month

The trends for dogs and cats are very similar, except the more noticeable spike for cats in summer months.

Stray Intake Subtypes

Across all years, 39% of strays come the field (counting Stray-Agency and ACO) and the 46% over the counter. 13% of stray intakes were Sun City or Community cats, and other subtypes are very infrequent (1% and lower).

Money Saved by RTH

This could be another useful metrics to reflect the benefits of RTH over other outcome types. It takes into account three components:

  1. The number of stray intakes with RTH outcome.
  2. The daily cost of care.
  3. The average difference in length of stay (in days) between strays with RTH outcomes and all other strays. This is shown in the table below – 17 days for dogs and 10 for cats. The average LOS shows an even more extreme difference of about 30 days, but the big difference from the median value suggests some particularly high values are swaying it, so the more conservative values will be used.

Let’s look at dogs, as these very by and large most RTHs:

There were 2095 strays who got RTH in 2019, 695 in 2020, and 349 in 2021 (up to end of June). Assuming 30$ cost of daily care per dog, and given the length-of-stay differences, We can estimate that return-to-homes saved the shelter \(2095*30*17=1,068,450\$\) in 2019, \(695*30*17=351,900\$\) in 2020, and \(349*30*17=177,990\$\) in 2021.

Any additional RTH saves roughly $510, such that returning even an extra 10% of the stray intakes for 2021 would result in saving roughly $100,000.

Species Outcome Count Average_Length_Of_Stay Median_Length_Of_Stay
Cat Other Outcomes 4608 26.00 11
Cat Return to Owner 92 2.09 1
Dog Other Outcomes 12485 31.25 18
Dog Return to Owner 3041 2.55 1

Supporting Data

Stray Intake and RTH Rate Maps

It was not possible to show the numbers of stray intakes and RTH rate per area because in the files recieved there was no available ZIP code for found location.

Found and Outcome Zipcode

It is also not possible to show whether animals were found in their home ZIP code and whether finders found animals in their home location because these ZIP codes are not present.

Data Status

  1. There are no frequently missing values!
  2. As mentioned, there is a found location, but it seems to include mostly street name and number, which makes it harder to analyze. Also, the addresses seem to repeat a lot.
  3. There is a ‘microchip’ value in both intake subtype and outcome subtype value options, but they are both used very infrequently. An indication of microchip upon intake could be helpful for analyzing prevalence and relationship to RTH.
  4. There are about 8 values of intake subtypes that were used less than 10 times – it might help to remove some values off this list (Confined, Boarding, Court Order, County - Straym Kab Specimen, Hoarding, Quarantine, Transport Transfer)
  5. Same goes for outcome subtype with even more values.

Extra Metrics

Other things we could show if we had the data for it:

  1. Exact distances traveled by lost dogs from home, if home (outcome) address was also collected for successful RTH.
  2. Prevalence of microchips across town (for example, are there areas from which more animals come in without chips?) and the RTH rates for animals found with/without chips.
  3. Reclaim fees (could be a yes/no to track fee waiving).
  4. Number of public found reports and successful RTH by public (if this data is accessible to the shelter; these two would allow showing $ saved by public RTH).